IF EXISTS (SELECT *
           FROM INFORMATION_SCHEMA.VIEWS
           WHERE TABLE_NAME='vInOutProdDetail'
           AND TABLE_SCHEMA='dbo'
          )
          DROP VIEW dbo.vInOutProdDetail
GO

CREATE VIEW dbo.vInOutProdDetail
AS
/*@@*_____________________________________________________________________


_____________________________________________________________________*@@*/

  SELECT
    InOutProdDetail.*,
    InOutProdPaper.[Date],
    InOutProdPaper.[Type]
  FROM
    InOutProdDetail
    
    INNER JOIN dbo.InOutProdPaper
		ON InOutProdDetail.InOutProdPaperId = InOutProdPaper.Id



